.. _`Unique Table`:

.. _`org.sysess.sympathy.data.table.uniquetable`:

Unique Table
~~~~~~~~~~~~

.. image:: unique_table.svg
   :width: 48


For each unique value in selected columns only keep the first row with that value. When multiple columns are selected, unique combinations of values are considered.



**Documentation**

The Table in the output will have no more rows than the incoming Table.


**Definition**


*Input ports*

    :Input:  table

        Input


*Output ports*

    :Output:  table

        Output



*Configuration*:
    **Columns to filter by** (column)
        Columns to use as uniqueness filter.
    **Method** (method)
        Legacy: lacks support for time types and missing values are treated as NaN.
        Extended: supports time types and missing values are treated as separate a value.

.. automodule:: node_table_unique
    :noindex:

.. class:: UniqueTable
    :noindex:






**Example flows**

* :download:`UniqueTable.syx </_examples/Sympathy/Data Processing/Select/UniqueTable.syx>`